Interface: SHOP - XML Measurement unit conversion Version 2010.30

This documentation describes the AbaConnect Interface XML Measurement unit conversion for the SHOP Application.


General Information

General information about the AbaConnect interface.

AbaConnect Interface Information
Application :SHOP
Interface Name :XML Measurement unit conversion
ID :XML UnitConversion ( Masterdata )
Version :2010.30
Status:Productive


Displays the possible import and export features for this interface.

Export / Import Modus
Export :XML
Import :XML


Displays additional information for this interface.

Additional Information

                                  Highest field Revision for this interface : 0



Mapping Information

The following displays the Mapping details for this interface.

Mapping Information
Mapping ID :AbaDefault
Mapping Name :Measurement unit conversion
Description :

                



Example AbaConnect XML Structure

The following is an example of an XML Header structure. This information is also visible in an AbaConnect XML Export file, that has been exported via the Abacus AbaConnect User Interface.

AbaConnect XML Struktur
<?xml version='1.0' encoding='UTF-8'?>
<AbaConnectContainer>
  <TaskCount>1</TaskCount>
  <Task>
    <Parameter>
      <Application>SHOP</Application>
      <Id>XML UnitConversion</Id>
      <MapId>AbaDefault</MapId>
      <Version>2010.30</Version>
      <!-- Attention : The client number (Mandant) is optional and implies that the data can only be imported into specified client (Mandant) -->
      <!-- The Client Option (Mandant) only has an influence when importing data. It can be configured in the AbaConnect Export Settings. -->
      <!-- By default, the client number (Mandant) is not written to the export file -->
      <Mandant>7777</Mandant>
    </Parameter>
    <Transaction>
      <UnitConversion mode='SAVE'>
          <!-- The specific data fields for the AbaConnect interface are included here. -->
      </UnitConversion>
    </Transaction>
  </Task>
</AbaConnectContainer>



Example AbaConnect Command Line

The following includes examples of AbaConnect Command Line. The AbaConnect Command Line is executed with the abaconnectexportconsole.exe and abaconnectimportconsole.exe programmes. The AbaConnect Command Line must be run direct on the Abacus server. More detailed information about AbaConnect Command Line is available on the Abacus Homepage. The following examples serve as starting point for creating a simple command line.

AbaConnect Command Line
Export :
abaconnectexportconsole.exe "/USRuser" "/PWxxx"  "-aSHOP"  "-version2010.30"  "-M7777"  "-acidXML UnitConversion"  "-mapidAbaDefault"  "-datamodeXML"  "-responseYES"  "-responsefileX:\response.xml"  "-exportfileX:\data.xml"

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx"  "-aSHOP"  "-version2010.30"  "-M7777"  "-datamodeXML"  "-responseYES"  "-responsefileX:\response.xml"  "-importfileX:\data.xml"

N.B. : For importing XML data, it is not necessary to specify the Interface ID and Mapping on the Command Line. This information is contained in the XML Import file.



Mapping Structure

The following displays a simplified mapping structure for this interface.
The XML-Element and Parent-Name are always in english. Click on the row to display additional information.

XML Element Name Field Name Parent Name Type Length Mandatory
UnitConversionUnits of measurement - relations---Yes
    - AdressNumberAddress no.UnitConversionNumber10Yes
    - ContactNumberContact no.UnitConversionNumber4Yes
    - CodeTypeUnitConversionNumber4Yes
    - DirectionDirectionUnitConversionNumber2Yes
    - EIOUnitNumberORDE unit no.UnitConversionNumber4Yes
    - FactorFactorUnitConversionNumber12Yes
    - FreeIdFree identificationUnitConversionText40No
    - UnitIdMeasurement unitUnitConversionText4No
    - StandardIdStandard IDUnitConversionText20Yes
    - PriceFactorPrice factorUnitConversionNumber12Yes
    - FieldFactorFactor table fieldUnitConversionText40Yes
    - FieldPriceFactorPrice factor fieldUnitConversionText40Yes



Field Information

The following is a detailed description of the fields used in this interface.

Address no.
XML Element Name:AdressNumber
Parent Element:UnitConversion
Field Type:Nummer
Action Type:Import und Export
Field Length:   10Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "AdrInr")
                    

Contact no.
XML Element Name:ContactNumber
Parent Element:UnitConversion
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "AkpNr")
                    

Type
XML Element Name:Code
Parent Element:UnitConversion
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "Code")
                    

Direction
XML Element Name:Direction
Parent Element:UnitConversion
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "Direction")
                    

ORDE unit no.
XML Element Name:EIOUnitNumber
Parent Element:UnitConversion
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
If code is 1 or 3
(The internal field ID for this element is "EIOUnitNr")

Factor
XML Element Name:Factor
Parent Element:UnitConversion
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   8Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
E.g. StdID=MTR EIOUnitNr = 17 (mm), Factor StdID to EIOUnitNr = 1000 1 meter = 1000 millimeter
                  StdID=MMT EIOUnitNr = 16 (m), Factor StdID to EIOUnitNr = 0.001 1 millimeter = 0.001 meter
                  The factor must not be less or equal to zero.
                
(The internal field ID for this element is "Factor")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Free identification
XML Element Name:FreeId
Parent Element:UnitConversion
Field Type:Text
Action Type:Import und Export
Field Length:   40Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
For codes 1 or 2
                  Must not be used if StdID is defined
                
(The internal field ID for this element is "FreeId")

Measurement unit
XML Element Name:UnitId
Parent Element:UnitConversion
Field Type:Text
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
If code is 2 or 3
(The internal field ID for this element is "MassId")

Standard ID
XML Element Name:StandardId
Parent Element:UnitConversion
Field Type:Text
Action Type:Import und Export
Field Length:   20Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
Relation to ZUM.StdID if code is 1 or 2
                  Must not be used if FreeID is defined
                
(The internal field ID for this element is "StdId")

Price factor
XML Element Name:PriceFactor
Parent Element:UnitConversion
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   8Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "PriceFactor")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Factor table field
XML Element Name:FieldFactor
Parent Element:UnitConversion
Field Type:Text
Action Type:Import und Export
Field Length:   40Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "FieldFactor")
                    

Price factor field
XML Element Name:FieldPriceFactor
Parent Element:UnitConversion
Field Type:Text
Action Type:Import und Export
Field Length:   40Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "FieldPriceFactor")